Mastering Productivity in Spreadsheets

• Computing
• Further Education (Key Stage 5)

Mastering Productivity in Spreadsheets

Mastering Productivity in Spreadsheets

Learning Objective

Understand how to use spreadsheet features to improve productivity, accuracy, and usability.

What do you already know about spreadsheet features?

Basic Cell Manipulation

1. Learn how to input data into cells.
2. Understand how to format cells (text formatting, borders, colors).
3. Perform basic arithmetic operations.
4. Use basic functions (SUM, AVERAGE).

Creating a New Google Sheet

Open Google Sheets and create a new blank spreadsheet

Follow the Activity: Basic Cell Manipulation in Google Sheets

Complete Entering Data

Formatting Cells

You should now have something like this:

Basic Functions Demonstration

SUM function

Average function

Auto filling using the fill handle

Decreasing decimal places

Using basic functions

Your spreadsheet should now look like this:

Time to add some formatting

Some more formatting

Chart Demonstration

Bar chart

How to select the range

How to customise it as needed

Edit the Horizontal and Vertical titles

Add a Title

Chart Demonstration

Bar chart

How to select the range

How to customise it as needed

Edit the Horizontal and Vertical titles

Add a Title

Conditional Formatting

Highlights outcomes based on specified conditions, enhancing data interpretation.

Cell Formatting

Involves colors, shading, merging cells, and alignment for improved data presentation.

Data Manipulation

Utilizes filters, sorts, and pivot tables for organizing and analyzing data effectively.

Formulae and Functions

Covers basic arithmetic operations, functions like sum, average, count, as well as logical functions.

Data Validation and Referencing

Involves ensuring data accuracy and using relative/absolute cell referencing for efficient calculations.

Boxes and Data Entry Forms

Includes lists, drop-downs, and data entry forms for streamlined data input.

Lookup Tables and Nested IF Functions

Enables efficient data retrieval and complex conditional logic in spreadsheets.

Cell Protection and Charts

Involves protecting cells from unwanted changes and creating various types of charts and graphs.

Chart Formatting and Worksheets

Includes formatting elements like titles, resizing, labels, and managing worksheets effectively.

Named Ranges and Goal Seek

Utilizes named ranges for easier cell referencing and explores the 'what if' function for scenario analysis.

Macros and Conclusion

Involves automating repetitive tasks and summarizing the key learnings from the lesson.

Write down 3 things you learned in this lesson.

Have students enter three things they learned in this lesson. With this they can indicate their own learning efficiency of this lesson.

Write down 2 things you want to know more about.

Here, students enter two things they would like to know more about. This not only increases involvement, but also gives them more ownership.

Ask 1 question about something you haven't quite understood yet.

The students indicate here (in question form) with which part of the material they still have difficulty. For the teacher, this not only provides insight into the extent to which the students understand/master the material, but also a good starting point for the next lesson.